Show the code
db <- "/Volumes/LEEF/0.RRD/LEEF 1/LEEF.RRD.sqlite"
options (RRDdb = db)
unlink (c ("~/Desktop/1.pre-processed.data/toc/" , "~/Desktop/2.extracted.data/toc/" ), recursive = TRUE )
pre_processor_toc ("~/Desktop/0.raw.data/" , "~/Desktop/1.pre-processed.data/" )
[1] "Log file set to ~/Desktop/1.pre-processed.data//toc/toc.log"
########################################################
########################################################
Show the code
extractor_toc ("~/Desktop/1.pre-processed.data/" , "~/Desktop/2.extracted.data/" )
[1] "Log file set to ~/Desktop/2.extracted.data//o2meter/o2meter.log"
########################################################
Processing LEEF_21_09_20 und 21_09_22 C.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_09_24 1-8.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_09_24 und 21_09_27 B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_09_27 restB.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_09_29t.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_01.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_04 S22 - S30.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_04 und 21_10_06A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_06.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_08.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_11.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_13.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_15 s8 - 26.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_15.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_18.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_20.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_22.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_25.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_27.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_10_29 und 21_11_01.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_11_03 und 21_11_05.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_11_08 und 21_11_10.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_11_12.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_11_17 und 21_11_19.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_11_22 und 21_11_24.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_11_26 und 21_11_29.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_12_01 und 21_12_03A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_12_03B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_12_06 und 21_12_08 1-8A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_12_08B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_12_10 und 21_12_13.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_12_15 und 21_12_17.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_12_20 und 21_12_22.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_12_24.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_12_27 und 21_12_29.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_12_31 und 22_01_03.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_21_15_10 rest 2.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_01_05 und 22_01_07A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_01_10 und 22_01_12.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_01_14 und 22_01_17.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_01_19 und 22_01_21A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_01_19 und 22_01_21B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_01_24 und 22_01_26.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_01_28 und 22_01_31A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_02 und 22_02_04.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_07B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_07D.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_09 und 22_02_11A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_14 und 22_02_16A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_16B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_18A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_18B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_21A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_23A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_25.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_02_28.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_02.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_04.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_07.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_09.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_11.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_14.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_16.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_18.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_21.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_23.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_25.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_28.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_30A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_03_30B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_01.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_04A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_04B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_06.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_08.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_11.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_13.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_15A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_15B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_18.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_20.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_22.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_25.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_27.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_04_29.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_02.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_04.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_06.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_09.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_11.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_13.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_16.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_18.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_20.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_23A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_25A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_27A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_05_30A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_06_01A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_06_03A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_06_06A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_06_08A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_06_10B.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_06_13A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
Processing LEEF_22_06_15A.txt ...
|- Processing metadata ...
|- Processing measurement parameter ...
|- Processing actual data ...
########################################################
Show the code
add_to_and_overwrite_table_in_RRD (input = "~/Desktop/2.extracted.data/" , dbname = db, overwrite = TRUE )
Show the code
toc <- LEEF.analysis:: db_read_table (table = "toc__toc" ) %>%
collect ()
toc_original <- toc
# conn <- DBI::dbConnect(
# drv = RSQLite::SQLite(),
# db = db
# )
#
# DBI::dbBegin(conn)
# DBI::dbWriteTable(
# conn,
# name = "toc__toc_original",
# value = toc_original,
# overwrite = TRUE,
# append = FALSE
# )
# DBI::dbCommit(conn)
#
# DBI::dbDisconnect(conn)
toc$ id <- 1 : nrow (toc)